load data
infile 'd:\test.csv'
append into table tmp1
fields terminated by  ','
(name1,
name2,
a2,
a3,
num,
all_name)